Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ContainerTypeCode (FK)(PK) | A category of container that defines what it is made of, its type (primarily its material handling category - e.g. 55 gallon drums, pallets, cases, etc.) and its shape. | CD_CNR_TYP | Code | varchar(20) | ContainerType(ID_TYP_CNR) |
MaterialReceivingLevelCode (FK) | A code to denote the level at which the item is received where level refers to a pallet, carton, or some other aggregation. This code is equivalent to the UCC-735 hierarchical-level-code. | LU_LV_MTR_RCV | Code4 | char(4) | SupplierItemReceivingLevel(CO_LV_SPR_ITM_RCV) |
SupplierID (FK) | A unique system assigned identifier for the Supplier. | ID_SPR | Identity | integer | SupplierItem(AS_ITM_SPR) |
SupplierItemID (FK) | The code assigned by the supplier to uniquely identify the ITEM | ID_ITM_SPR | Identity | integer | SupplierItem(AS_ITM_SPR) |
UnitOfMeasureCode (FK) | The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. | CD_UOM | Code | varchar(20) | UnitOfMeasure(CO_UOM) |
DepthCount | Defines the depth of a supplier item pack unit in supplier-item-linear-measure-unit-codes. | QL_UN_RCV_DPTH | Quantity | DECIMAL(9,3) | |
WidthCount | Defines the width of a supplier item pack unit in supplier-item-linear-measure-unit-codes. | QL_UN_RCV_WD | Quantity | DECIMAL(9,3) | |
HeightCount | Defines the height of a supplier item pack unit in supplier-item-linear-measure-unit-codes. | QL_UN_RCV_HT | Quantity | DECIMAL(9,3) | |